<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>How to filter at the data set level</title>
    <link rel="StyleSheet" href="css/filter.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="fl-HowToFilterRheRowsToRetrieveFromAJDBCDataSource.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="fl-HowToFilterAtTheReportElementLevel.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h4 class="N_hth_HowToHelp"><a name="138199">How to filter at the data set level</a></h4>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="229619">In Data Explorer, right-click the data set from which to filter rows, then choose Edit. Edit Data Set displays the query for the data set, as shown in </a><a href="#279728" title="How to filter at the data set level">Figure&nbsp;10-1</a>.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="229628"><img class="Default" src="images/basic_query.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 10-1 Edit Data Set displaying the query" /></a></p>
      <div class="fc2_FigCall2TitleFirst">
        <b class="Bold">Figure&nbsp;10-1&nbsp;&nbsp;</b><a name="279728">Edit Data Set displaying the query</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="224623">Choose Filters from the left side of the window. Edit Data Set displays filter information, as shown in </a><a href="#224632" title="How to filter at the data set level">Figure&nbsp;10-2</a>.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="224630"><img class="Default" src="images/add_ds_filter.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 10-2 Edit Data Set displaying filtering information" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;10-2&nbsp;&nbsp;</b><a name="224632">Edit Data Set displaying filtering information</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="215550">Choose New to create a filter condition.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="215554">In New Filter Condition, specify the following values:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b2_Bullet2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b2_Bullet2_inner" style="width: 14.1732pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b2_Bullet2_inner"><a name="215563">In the first field, select a field from the drop-down list. Alternatively, open the expression builder to create a more complex expression.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b2_Bullet2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b2_Bullet2_inner" style="width: 14.1732pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b2_Bullet2_inner"><a name="215578">In the second field, select an operator from the drop-down list.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b2_Bullet2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b2_Bullet2_inner" style="width: 14.1732pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b2_Bullet2_inner"><a name="215582">In the third field, specify the value to search. Type the value, select from the list of values, or use the expression builder to create a more complex value expression. If you select the Is True, Is False, Is Null, or Is Not Null operator, a value is not required.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b2_Bullet2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b2_Bullet2_inner" style="width: 14.1732pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b2_Bullet2_inner"><a name="215579">In the fourth field, which appears only if you select the Between or Not Between operator, specify a value. </a><a href="#224604" title="How to filter at the data set level">Figure&nbsp;10-3</a> shows an example of a filter condition.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i3_Image3"><a name="224602"><img class="Default" src="images/newfilter.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 10-3 New Filter displaying a filter condition" /></a></p>
      <div class="fc3_FigCall3Title">
        <b class="Bold">Figure&nbsp;10-3&nbsp;&nbsp;</b><a name="224604">New Filter displaying a filter condition</a></div>
      <div class="N_i_Indent1"><a name="220905">Choose OK to save the new filter condition. </a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">5&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="224580">To create additional filter conditions for the data set, repeat steps </a><a href="#215550" title="How to filter at the data set level">3</a> and <a href="#215554" title="How to filter at the data set level">4</a>. <a href="#224592" title="How to filter at the data set level">Figure&nbsp;10-4</a> shows two examples of filter conditions created for a data set. <a href="#224089" title="How to filter at the data set level">Figure&nbsp;10-5</a> shows the rows that the data set returns.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="224590"><img class="Default" src="images/dataset_filter.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 10-4 Edit Data Set displaying the filter conditions for the data set" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;10-4&nbsp;&nbsp;</b><a name="224592">Edit Data Set displaying the filter conditions for the data set</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">6&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="224326">Choose Preview Results to verify the results that filtering the data set returns. If you specified multiple filter conditions, the data set returns only rows that match all filter conditions, as shown in </a><a href="#224089" title="How to filter at the data set level">Figure&nbsp;10-5</a>. To return rows that match any one of the filter conditions, create a single filter condition that contains an OR expression, then select the Is True operator.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="224087"><img class="Default" src="images/dsfilter_results.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 10-5 Preview Results shows only rows that meet both filter conditions" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;10-5&nbsp;&nbsp;</b><a name="224089">Preview Results shows only rows that meet both filter conditions</a></div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>